<!--#include file="top.asp"-->

<div>YKPS Student Report Cards</div>
<div><a href="./index.asp">Class List</a></div>


<%
Dim rs_stu_list, i, rs_fields_count,str_stu_list
Set rs_stu_list = server.CreateObject("ADODB.Recordset")
stu_class = request.QueryString("stu_class")
str_stu_list = "select * from student where stu_class = '" & stu_class & "'"

rs_stu_list.open str_stu_list, conn
%>

<table border="1" width="90%">
	<tr>
  	<td>Student Number</td>
    <td>English Name</td>
    <td>Chinese Name</td>
  	<td><a href="./ind_subject.asp?grade=<%=rs_stu_list.fields("stu_grade")%>&amp;ind_subject=ind_summary">Summary</a></td>
  	<td><a href="./ind_subject.asp?grade=<%=rs_stu_list.fields("stu_grade")%>&ind_subject=ind_mandarin" >Mandarin</a></td>
  	<td><a href="./ind_subject.asp?grade=<%=rs_stu_list.fields("stu_grade")%>&ind_subject=ind_math" >Math</a></td>
  	<td><a href="./list_english.asp">English</a></td>
  	<td><a href="./ind_subject.asp?grade=<%=rs_stu_list.fields("stu_grade")%>&ind_subject=ind_eu ">EU</a></td>
  	<td><a href="./ind_subject.asp?grade=<%=rs_stu_list.fields("stu_grade")%>&ind_subject=ind_music">MUSIC</a></td>
  	<td><a href="./ind_subject.asp?grade=<%=rs_stu_list.fields("stu_grade")%>&ind_subject=ind_ict">ICT</a></td>
  	<td><a href="./ind_subject.asp?grade=<%=rs_stu_list.fields("stu_grade")%>&ind_subject=ind_pe">PE</a></td>
  	<td><a href="./ind_subject.asp?grade=<%=rs_stu_list.fields("stu_grade")%>&ind_subject=ind_art">ART</a></td>
	</tr>

<%
Do While Not rs_stu_list.EOF
%>
	<tr>
	<td><a href="./rpt_student.asp?stu_id=<%=rs_stu_list("stu_number")%>"><%=rs_stu_list("stu_number")%></a></td>
	 <td><%=rs_stu_list.fields(1) %> </td>
	 <td><%=rs_stu_list.fields(2) %> </td>
	 <td><a href='./rpt_summary.asp?stu_id=<%=rs_stu_list("stu_number")%>'>Summary</a></td>
	 <td><a href='./rpt_mandarin.asp?stu_id=<%=rs_stu_list("stu_number")%>'>Mandarin</a></td>
   <td><a href='./rpt_math.asp?stu_id=<%=rs_stu_list("stu_number")%>'>Math</a></td>
	 <td><a href='./rpt_english.asp?stu_id=<%=rs_stu_list("stu_number")%>'>English</a></td>
	 <td><a href='./rpt_eu.asp?stu_id=<%=rs_stu_list("stu_number")%>'>EU</a></td>
	 <td><a href='./rpt_music.asp?stu_id=<%=rs_stu_list("stu_number")%>'>Music</a></td>
	 <td><a href='./rpt_ict.asp?stu_id=<%=rs_stu_list("stu_number")%>'>ICT</a></td>
	 <td><a href='./rpt_pe.asp?stu_id=<%=rs_stu_list("stu_number")%>'>PE</a></td>
	 <td><a href='./rpt_art.asp?stu_id=<%=rs_stu_list("stu_number")%>'>Art</a></td>
	 <td><a href='./rpt_isa.asp?stu_id=<%=rs_stu_list("stu_number")%>'>ISA</a></td>
	 <td><a href='./rpt_language.asp?stu_id=<%=rs_stu_list("stu_number")%>'>Language</a></td>
 	 <td><a href='./rpt_healthy.asp?stu_id=<%=rs_stu_list("stu_number")%>'>Healthy</a></td>
	 </tr>
<%
	rs_stu_list.movenext
Loop
%>
	<tr>
  	<td colspan="15"><a href="./ind_teacher.asp?class=<%=request.QueryString("stu_class")%>">Teacher Information</a></td>
  </tr>
  	<tr>
  	<!--<td colspan="15"><a href="./add_student.asp">Add a New Student</a></td>-->
  </tr>
</table>
<%
Call CloseConn()
%>
</body>
</html>